SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540540 LIMIT 1 [ RunTime:0.000727s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540540 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161032,455897,566640,1005461,866165,651359,986723,565307,803679,846198,416328,211595,928692,883563,494468,694189,870579,507534,1046429,399001,180885,414561,142398,243844,213093,383329,225145,177322,534758,185469,983401,293289,862645,897407,302386,906725,491933,1033939,477652,567817,376006,193393,84489,543560,44032,340249,895602,452214,343931,220107,99085,982835,190503,828369,337155,861007,485003,667133,620083,942438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]