SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473636 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473636 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991961,266491,510088,918671,568703,65291,285706,1020718,345379,214870,846784,326443,1017695,428897,337171,847956,752157,466173,567581,359629,436468,57481,461408,283031,518939,781070,758331,779658,52196,945773,467612,440588,482902,694951,813150,644446,188767,792138,317830,241,360985,544158,741647,400973,252651,161910,579689,205322,895018,97317,86300,338514,1010488,803005,505061,832289,731128,361509,910718,431952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473636 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473636 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000968s ]