SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263122 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263122 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805723,320479,466686,399948,683475,918630,398334,482763,417968,347866,129859,887881,397105,505049,868301,325569,643699,386168,193973,342624,447622,582163,1021338,1004370,76819,343520,483105,295223,782508,205377,99242,787407,240893,324751,144299,210485,52109,917343,683312,989429,862516,191545,191614,693644,955737,961817,760003,532600,1020156,132980,938522,962361,617881,261744,424827,489443,522099,862390,155443,340023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]