SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410089 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410089 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188034,589588,754158,669398,118773,418400,100738,942549,6933,275608,812228,626074,794865,890867,803426,270045,397396,172370,768468,650752,781249,887853,22167,741960,540033,1035174,925434,245386,496085,275838,767665,59554,274917,455495,409026,919360,35330,17787,617096,310005,291864,171916,643006,130730,67767,880710,818586,857615,266961,767488,455985,832365,888583,708928,665676,40288,241195,1016884,1034588,720709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]