SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431043 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431043 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319700,749637,933071,77044,57388,621180,282283,447320,487171,401715,570299,922683,987864,650704,671188,516536,786304,4762,716521,191229,590025,718160,93770,909323,719734,225843,1010089,719766,90066,326196,317426,982032,803551,892494,353807,614292,144244,342678,238502,189533,868757,262702,121066,82928,23793,563425,355051,830565,630897,687629,932382,231865,443913,462604,257064,444747,632795,38762,811281,543676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001782s ]