SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003967s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801880 LIMIT 1 [ RunTime:0.000521s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801880 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24212,799702,968410,339391,123467,275223,770567,71159,281518,181427,628421,277153,956230,1002705,332602,1020819,520062,298160,951806,771425,729500,1046841,565252,942550,611266,536340,454193,953776,781944,394168,950312,668810,230751,549087,46669,1016236,235714,522511,244260,562942,891448,853360,367533,382633,593525,659907,492518,756538,703903,328945,170754,269503,920911,530767,345567,446801,311541,464182,954013,278431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]