SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536320 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536320 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (379511,1043577,148621,178883,389943,763552,80371,1027829,520624,988885,373883,677103,250108,915593,590867,123474,18691,939102,225303,826905,185022,11035,499554,122014,65057,194506,697508,648670,818851,596000,918864,218790,529087,159735,1044789,416846,800786,164614,212896,431420,597460,323352,126975,380588,382883,650984,238790,492343,925834,123176,878830,566930,647625,438782,248359,120573,34441,415601,222411,8581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]