SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013947 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013947 [ RunTime:0.003269s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592726,459175,869567,204029,959612,771567,247955,510829,149168,73971,203038,783414,812275,920830,459237,372248,331130,441627,485559,171850,612019,67609,606251,895100,455398,880982,796539,181784,1017878,688809,992296,1047329,32432,749221,1002220,1025691,576048,717627,659072,405115,373143,393827,754468,189687,834822,740491,149603,513897,327909,478480,603183,44653,27972,983234,314648,530814,3792,702081,483723,684015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013947 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013947 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]