SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042189 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042189 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539410,572916,368271,83183,1013843,888093,96069,714092,99636,288461,1047319,673189,824432,57745,855702,496507,513864,539108,617889,691601,444714,127803,91757,1009190,272964,759459,777595,606334,125243,396793,817151,298343,326868,801752,379450,229034,1032209,41662,145955,881806,134635,24736,940340,436331,809713,515457,48657,12294,828799,898613,1005121,463077,624564,293972,968238,623254,445735,1040058,184176,564498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042189 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042189 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]