SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 741036 LIMIT 1 [ RunTime:0.000969s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 741036 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528571,893958,1043695,496309,666109,855764,166675,251159,393311,573116,537851,977093,168555,31468,628462,873746,154391,265701,528749,886909,909018,732235,228199,977551,487810,469294,465253,88920,449528,938059,967830,828503,90358,542745,745448,786539,634937,49496,784342,418335,921130,717394,948795,412629,1046073,382525,905883,426129,1030867,3159,1043255,725056,797350,147518,218678,825342,984644,822088,997249,426928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 741036 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 741036 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002140s ]