SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002019s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043217 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043217 [ RunTime:0.002632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193659,433671,58160,546092,438064,94849,384527,322572,612050,499696,971263,175572,307212,187167,137781,946521,952554,504471,452913,322088,478572,268618,1040291,301480,900129,898110,869312,934362,458720,867088,411009,885869,464995,959014,694583,465385,669490,501795,967290,898639,50077,178479,1004616,182734,1033728,449906,334989,56963,761860,295365,424175,753765,797156,905723,828271,353409,574471,764491,821306,411299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]