SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498519 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498519 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709493,595401,204816,674305,823593,32156,106215,288757,741603,218493,1043909,77424,10566,1020770,91682,637618,374434,1016515,17485,427111,840980,747293,1010342,73711,287737,564898,469150,232212,914187,14284,474793,423425,706888,644903,702739,512808,639522,182312,381152,876148,969930,366195,724713,8913,543080,35540,241613,825104,632458,571141,241347,551999,254796,281042,949665,703921,64045,967666,158903,385736) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498519 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498519 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001908s ]