SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205571 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205571 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (419205,263121,296730,206375,401566,265872,512306,930311,276917,774766,764937,339451,755841,650248,371109,215670,802564,52235,552668,44477,733682,986919,723623,377314,263271,283616,542426,738757,401657,48146,945899,195982,24762,119566,132182,509566,634979,944042,282828,800026,649944,871934,871330,471046,905681,892710,731386,25448,502549,358746,397079,848297,103881,193465,556319,617242,604481,550208,927845,517729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000914s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]