SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108451 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108451 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375358,247893,424183,887931,893580,726740,453463,218533,48003,148415,774688,87114,446167,847405,993989,639681,390412,531204,822283,731119,172678,427196,184173,737552,709633,162636,927735,56578,180645,938625,911991,529527,693524,90016,388171,402071,114385,13401,275405,465254,864456,261907,90395,466922,133800,299093,1033859,667162,193526,382496,583579,939546,123229,457451,537886,2748,949724,743401,324791,119827) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]