SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001462s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041894 LIMIT 1 [ RunTime:0.001936s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041894 [ RunTime:0.002320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547152,768538,865849,242190,947679,460558,934103,774107,680560,752805,441566,616181,495602,920772,231312,498245,172069,260662,77106,323367,545360,854585,364437,351430,435188,1019840,294391,179334,11855,408360,68738,385897,114688,932778,505239,817154,869555,958846,672543,677415,636493,972717,66239,308229,706405,341469,317200,242400,391876,375888,652300,397151,55773,565795,21012,432543,318009,1020053,189759,293282) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]