SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543978 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543978 [ RunTime:0.002151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (759697,30812,801567,38507,104610,650624,82078,348210,974527,689488,277363,923148,681458,443870,456614,390424,926987,441527,928460,463646,697764,827821,7911,416531,960537,824211,368440,266157,44615,174483,259585,908888,1026036,998192,400427,875576,476464,369972,129341,404755,746419,240932,220377,972369,924360,640311,866437,20915,346168,630038,432511,581073,970573,1006537,384357,902904,542394,541128,160892,814756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]