SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310599 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310599 [ RunTime:0.003137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998129,1048860,911051,828691,725939,479899,77273,335849,148708,56992,750036,1006432,150747,666079,618088,719750,404080,379693,39655,702214,195819,998085,281926,27972,732907,807966,146301,492053,733891,994612,256218,553363,654792,446924,535267,94325,471587,457949,808838,831488,550319,980152,138485,545062,672704,321726,632764,530251,29148,494404,438777,732076,13825,615237,19748,111489,205632,911390,329459,755542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]