SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380104 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380104 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130381,269178,362054,326712,305532,99059,848400,993976,572122,950321,594984,542790,39279,712846,607081,958047,233478,990446,905491,580926,726396,300252,664815,288919,445828,799585,59921,424312,781254,679374,534119,255408,244263,236533,328036,17326,101556,213930,440032,621181,468082,661093,1043049,1027879,366433,787692,884426,488590,272125,634072,318157,435405,303177,210793,690607,598724,659393,475444,914946,769395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]