SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418694 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418694 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247239,769678,744380,1029173,79129,443249,677028,475300,141479,263370,323868,529475,292079,67713,794940,312117,28090,372847,46616,469968,597393,551922,637811,1036151,249643,629396,963132,433742,384537,997672,751404,1005080,885132,338638,404453,70124,251286,383622,368216,697453,664570,486042,793833,994956,126396,874342,310158,19082,991938,834626,95627,672966,114832,462890,248008,121802,103626,145124,822423,344858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]