SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 974539 LIMIT 1 [ RunTime:0.000684s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 974539 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200910,393344,812163,675841,860864,165899,346018,700755,471278,249893,777153,13790,910914,146633,955876,185613,310425,83534,1024300,424192,144491,1003480,129453,671362,544316,469332,803621,877474,1048857,468121,265322,801399,9785,11141,336278,628402,867796,890819,418937,650154,877999,112080,874385,681002,137770,81837,488151,138108,542543,386132,145091,947321,955546,67386,142346,649460,389197,379829,442410,143628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 974539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 974539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]