SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504085 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504085 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108853,368180,617766,512754,433789,795004,585326,1032266,167055,974481,812060,509091,84223,750592,112335,390371,383914,284110,734393,39820,833390,275984,133151,788567,32784,656380,880998,91383,974778,63154,67714,933091,972114,121789,27781,718414,799369,310141,154430,617318,637213,110678,170516,222113,861054,342198,650811,515604,244111,200969,740800,638482,498525,286962,144480,353777,984413,667677,940794,458469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504085 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504085 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]