SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 342481 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 342481 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (491203,321363,777846,687732,19810,918190,214268,676322,303548,61169,574914,1019090,410588,109998,362192,121809,145186,946382,387014,616704,386818,16627,314213,861591,161988,401938,423208,456826,752222,450002,804092,1013324,489436,288215,894120,796117,711118,989254,881753,381461,817437,804183,446584,49338,944333,954614,542367,406971,575464,688606,610448,807390,105354,267152,14734,747123,280490,691464,689251,999739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 342481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 342481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000818s ]