SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488183 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488183 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242445,366179,867155,805841,297689,319783,886796,39464,363548,463122,705898,907585,345554,933237,938692,781676,36103,133854,424190,462110,618023,90118,107883,203808,843383,45314,980416,813094,230969,775528,459285,121039,197828,641821,752718,873923,281173,74889,217532,96152,327220,940850,999483,830779,105043,603726,584003,239787,669223,839175,521632,768275,22410,594870,241584,778071,138388,62915,849906,581040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]