SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 469320 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 469320 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462269,307658,238569,543476,679322,231323,166405,995095,299102,719096,250423,82021,159174,319556,1034445,299499,1004165,596747,210213,743674,819921,122403,1004901,363251,419592,464300,777683,848299,965943,1014155,236434,659617,1009773,105604,726548,41850,138001,344739,508826,734973,751304,256420,754438,664019,52026,150316,373229,795222,702080,1032668,417178,959607,645290,821555,1009768,20831,838019,47300,932212,397887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 469320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 469320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]