SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800002 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800002 [ RunTime:0.003837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (798243,87819,909283,127749,887525,706894,241556,887071,58156,914214,657084,146094,751910,932455,766975,811095,175857,95043,693833,66981,950212,259666,702472,944268,685884,969889,277550,317381,299170,410790,851665,105785,132077,1044939,781735,162891,340770,839272,334941,389965,41950,701083,932587,330139,130690,568568,350424,569657,58870,635658,777780,735325,124567,875797,235642,874231,481575,458610,193206,395943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001888s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]