SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001482s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396294 LIMIT 1 [ RunTime:0.000557s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396294 [ RunTime:0.003496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500311,694830,888930,81461,720789,994820,157011,926113,707649,514616,84334,825180,454870,327640,419653,504435,64644,341073,235349,843903,148313,78276,242417,613625,899738,55224,143099,364735,435611,923911,358092,134276,760988,268700,970640,635044,867715,843552,180112,261585,654723,461876,644726,508759,83347,268785,313184,237829,965709,553269,909593,185877,550496,73678,1032929,75668,577445,1027046,372450,138614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]