SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001585s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411811 LIMIT 1 [ RunTime:0.001671s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411811 [ RunTime:0.004356s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665788,691037,279680,106722,663729,164176,177341,473257,452570,524058,168410,941343,663714,393939,739893,49243,929568,344390,292958,85169,829116,389018,670320,563665,480703,17590,723361,535337,810031,157566,423604,987304,469549,1031384,123588,897560,225064,43463,186274,179218,203793,626793,933729,1029910,1036548,364301,842212,50954,499268,737728,1032000,754272,993766,953921,113355,344467,425392,878790,159754,798315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]