SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412213 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412213 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (756150,954105,288143,782175,467210,359403,705217,190176,433525,885331,281601,354331,930282,185464,453508,814046,1042471,619586,1016382,228915,750759,354618,339699,324747,1031103,527703,978014,982349,417284,914264,345226,1047279,876281,390951,148103,828586,367757,485145,877451,885738,710736,1023407,271389,286412,84461,293845,460148,699510,914868,174538,590006,799884,914290,789338,24409,960439,884988,385948,136964,696366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]