SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489009 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489009 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177547,846402,943449,805013,250800,425156,545009,117375,193104,137134,515136,500798,1022508,784391,428941,758690,78018,734241,468516,54894,190686,671996,997720,318564,871871,562379,550158,607746,146263,95705,184395,787487,272157,836532,293448,826127,752916,791171,890283,1000504,573748,329975,1013170,895634,919758,524708,994373,848984,450429,966694,235411,950974,638559,360449,488645,643244,851895,561505,11228,710675) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]