SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046276 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046276 [ RunTime:0.001939s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757987,919789,14971,104702,350972,739114,83622,553488,336484,213043,853677,100062,927469,139798,29049,588090,303337,599173,361265,781752,639683,100441,97742,144702,505985,471534,165783,331866,623327,556611,244785,1033713,787645,232888,782237,66874,834376,840954,496568,864337,1033440,422099,799301,331994,157173,806458,844839,132654,108337,1035938,856548,740740,792291,691957,132673,434073,537163,763720,653186,436679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]