SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520670 LIMIT 1 [ RunTime:0.000605s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520670 [ RunTime:0.002908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387165,798592,1044504,421075,97212,366306,822173,1006723,82147,1016995,720525,1030168,614838,176289,68243,215025,543925,878056,224213,117725,966899,465386,51065,580844,734800,169843,418911,911454,750673,1046025,857872,291728,630437,1028907,265255,144018,703751,530038,299179,922094,206489,1020915,303771,164263,681232,994719,757021,987096,996188,70162,841570,641298,172865,236141,488107,612508,809714,871997,853064,379494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]