SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456710 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456710 [ RunTime:0.003631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (751793,1006534,604947,518462,988154,491326,70399,908993,726603,600183,1017785,128978,336554,554040,582833,144807,990765,754098,84777,921743,609755,428668,251218,542524,793324,51332,471304,760593,822613,98583,53702,530774,793987,468858,145386,245520,361581,421011,857910,994195,297915,925245,580321,615566,260824,6265,727791,16452,792502,172394,428023,698618,724663,669809,7206,433012,556493,117896,584797,962299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]