SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328830 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328830 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (972401,42654,624016,160449,636883,266478,1007140,367199,844832,547996,189895,282048,836071,352339,781211,510363,831434,27233,810149,457452,34555,963863,461755,142940,516400,687626,891141,648440,489501,599416,754333,607456,613498,103277,633079,489480,157202,496288,456882,232608,741166,1030693,639300,656399,627458,73316,592683,605980,86087,193111,794146,195238,877181,91932,525127,927720,1025468,979922,685767,388250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]