SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483941 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483941 [ RunTime:0.002875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153792,857069,1010766,800552,341451,242272,443772,243354,37470,284408,568542,783454,390361,960214,330398,1047333,86429,369457,900596,571290,876455,547028,162467,158313,1023733,290161,174691,35937,360220,941905,689469,865028,174450,734604,724077,666560,915881,935557,291121,82927,277222,731034,163529,422569,504149,804854,773973,121395,538101,800945,90665,1008614,669872,832097,548303,941188,1011210,143599,83377,284108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]