SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539580 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539580 [ RunTime:0.002877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458259,952394,297153,61308,399563,988936,1014366,140121,315311,137786,783839,741822,521851,171134,702705,282818,1044629,442392,961007,581328,566409,914283,220989,805978,129433,487303,916235,164081,418466,404312,34439,911627,691031,65154,358058,665091,154665,399037,442276,133339,159554,883399,14129,993195,712490,345283,436231,817790,501255,13645,679450,262430,268637,221061,125159,816619,333903,788948,786409,957150) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]