SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341288 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341288 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201802,804541,911193,263228,817139,387674,1019181,673006,115933,666878,710598,252844,42346,216056,39548,953062,416580,9053,42397,762298,824611,115009,293172,804511,667800,766912,523261,492312,114231,848032,485593,182674,890134,928530,611885,560010,686398,899221,446126,783475,774155,594491,774925,6686,209045,12101,81976,433654,412154,128288,479857,911360,120990,945873,505947,715792,264123,264683,628844,63241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]