SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001670s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026477 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026477 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407893,349934,317847,144736,852093,360492,619880,177630,481628,364414,524323,980162,104113,911900,916037,391840,857730,90360,334571,398290,975917,85429,429615,838742,286409,202702,1027131,787411,363065,231658,1016651,883719,1022766,118068,111216,679569,562820,149963,227844,737142,204249,366078,592520,400469,1003276,1023082,917894,564619,924518,155344,909647,74736,763473,458039,438301,618192,471694,1023951,933613,475922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026477 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000855s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026477 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]