SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333313 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333313 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (681530,996300,483645,625907,804265,328137,510062,114732,152335,579780,680459,350307,964760,625809,414539,707324,1009844,250161,342186,888532,602593,226817,598243,804574,1048146,146688,1002400,412048,341879,31759,756456,693042,886935,39631,21815,960899,69925,339431,712473,935595,216265,777364,559635,207418,415840,677107,905801,886769,441405,331373,553325,824224,160136,413634,846722,940461,144892,744150,829203,572319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]