SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 233918 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 233918 [ RunTime:0.002488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465328,352909,623031,577386,1033661,806243,172936,725551,728587,1011214,611082,470041,631543,323630,40427,334972,471024,841430,336605,456775,337215,810168,23447,260770,401803,85197,480428,306279,9046,176166,236528,175027,734622,618184,1000908,111234,440943,11798,169252,247560,774247,664132,832519,331824,1027159,5143,935016,725646,223066,17438,108129,82324,53370,454390,524292,166304,865791,320905,971845,387401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 233918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 233918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]