SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036705 LIMIT 1 [ RunTime:0.001090s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036705 [ RunTime:0.005912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969769,523171,726082,392990,51607,325730,839242,735162,361411,506737,671462,783574,711740,615241,833944,347803,183093,197536,522563,39066,31293,937711,572341,411852,971846,587337,1001806,589395,784670,81103,833159,602538,207852,187247,505205,547290,702418,131545,991493,827376,45751,168160,260585,647947,126815,391574,205658,769880,457488,257144,1009122,347466,618762,1006214,960233,1002330,24257,142996,110952,936610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001703s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]