SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411805 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411805 [ RunTime:0.002213s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179182,436652,29075,977664,179687,411512,443582,535024,571586,952188,962969,701722,986991,909510,480695,686079,598757,1006653,1028120,587074,980704,599392,742751,768300,531110,810733,507673,335918,243899,216752,821457,371333,817086,924044,47656,171355,381750,773706,217431,396374,77368,472867,841114,707826,1001817,974755,702907,998867,100029,1043592,567055,186309,121147,993047,461385,160635,475619,550200,181822,325571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]