SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 785183 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 785183 [ RunTime:0.003470s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367726,583326,848540,414506,904454,552014,452070,311751,352270,221879,476443,954071,1002202,259396,807499,176006,641624,951046,749206,354541,569618,784111,17628,71679,508853,271878,787635,977080,97519,1046126,727076,989169,955846,226640,1035029,339773,676719,62058,950521,388461,916578,338106,723438,928220,957940,595295,46959,621402,993183,275096,847830,640998,899896,63351,58133,290024,378419,775909,360403,418873) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 785183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 785183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]