SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001505s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532118 LIMIT 1 [ RunTime:0.001215s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532118 [ RunTime:0.003562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94465,775288,934440,321449,773747,721131,897336,98620,256174,927586,114248,914179,329082,196078,752297,526632,420024,849807,676242,412641,720182,894234,793023,1002884,549981,194459,325301,789883,768046,519345,723198,72322,104205,586072,730255,897433,637526,444069,442289,10966,618261,334811,422519,180062,823875,811975,576607,209092,498653,382425,1037495,976400,370957,546524,365641,131319,891259,314561,515080,171220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]