SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 808570 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 808570 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46521,611437,406666,99368,40753,391134,113700,125700,337403,353278,745325,297926,707346,801271,178066,231972,946097,930274,306975,697286,958225,573135,283298,715448,732741,287676,176889,1024168,971243,123695,797522,205212,539969,477982,874837,867923,100395,845133,361135,1040930,137642,57509,172271,493149,975975,434030,672019,777477,359740,822401,325349,784952,40233,175008,639803,930685,366627,847747,401153,947331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000938s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 808570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 808570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]