SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002870s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29383 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29383 [ RunTime:0.003239s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370899,984480,382517,374053,916934,912884,653618,844071,597707,233516,627350,32195,530557,929729,360407,942562,126969,473681,220105,509231,652290,338084,856406,729125,383370,634884,814511,949669,750660,480657,398788,454688,1035954,362763,709669,837217,362499,242491,686924,378179,271975,673311,789450,750579,275284,474562,909460,686917,840619,315060,24577,897369,528139,606176,404990,10826,383527,427104,234186,88712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]