SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002660s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406987 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406987 [ RunTime:0.002720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488606,634009,547846,718722,542565,885136,923463,48416,377866,749679,977180,231259,501891,624470,854380,1043386,337944,100895,535207,354350,785341,347415,656364,149441,693516,142598,715611,632767,59566,936695,250158,625834,960144,994036,427356,102475,663709,362507,706449,182876,138050,566444,700820,497732,756984,997380,949078,925016,459310,216449,377437,390730,448482,221089,259340,319590,145886,1035090,561885,876025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001847s ]