SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332474 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332474 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628160,770382,270541,124462,665632,170489,162017,832552,212711,933792,371876,701171,17171,281373,223074,208585,1044068,135063,226513,808420,605662,146482,74639,736246,615074,475051,375434,893740,835259,181016,1026502,492309,745237,355315,679227,877778,143517,890995,378404,325290,443088,612260,859222,355602,257545,604729,274020,337865,33185,908183,128032,1015728,162717,216661,1035289,863070,76360,840885,1046189,280361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332474 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332474 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]