SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381189 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381189 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018591,756645,960917,840618,418175,523586,56850,1034196,842757,605317,15476,886549,285094,270489,725716,902765,556013,256912,72380,97844,117120,279896,244721,478390,341911,219069,695503,78539,819054,308052,176321,727754,1013302,789857,119923,931938,31181,325406,78585,128624,383699,523281,44341,613212,704318,853504,435641,969898,633915,108650,960358,32275,643703,62477,292397,988215,355675,258931,528093,269923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]