SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002656s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 378410 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 378410 [ RunTime:0.001970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529963,856310,111695,998351,725891,757334,554925,37310,475910,806928,256013,671972,1028702,703426,437527,814908,414146,889753,890786,374441,1024246,1018652,559752,317959,68333,459814,762735,325768,456434,755403,28815,969960,441177,546458,907076,997225,93828,796179,46798,185123,160436,109990,686047,388011,230900,58648,1037033,659588,524308,896473,188357,439655,791648,934950,649592,465219,119831,272690,827724,298528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 378410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 378410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]