SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 525166 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 525166 [ RunTime:0.003776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533211,589006,444990,464911,658787,186135,430791,575929,1011049,420203,503265,48299,314360,208684,574760,428729,831480,880493,755890,145711,328508,721701,807552,647464,242737,108958,863384,761746,396240,210624,484123,57231,653111,141628,893349,99710,755581,1034180,394178,577725,22308,415567,883803,57640,774662,354703,9157,356544,408428,439709,899257,831006,615580,73484,959880,95349,474537,677414,435161,1011425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 525166 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 525166 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]