SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29916 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29916 [ RunTime:0.002396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577836,498739,195770,37583,119490,490908,502591,505938,449070,553908,215163,935685,651584,985642,815466,279763,700342,1002064,873591,73686,497743,775633,1048762,129957,20463,386623,963226,480367,437357,577951,460899,667441,842591,841849,331080,831682,443927,164000,447034,875152,681079,799796,151343,166685,725837,1037779,92391,913555,521448,253096,49478,855754,724229,621383,502853,887612,673737,981348,569000,713690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]