SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 979610 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 979610 [ RunTime:0.002523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61103,957637,691203,558426,223460,660767,828883,191944,233205,915734,249405,98478,418497,650422,96469,263625,564168,452672,159210,81367,81782,536155,274437,430702,686555,383016,290485,25885,595512,165935,258525,53418,471730,475058,657601,88533,917912,452439,510021,216032,194778,449971,909624,15717,867232,925231,959793,802233,101629,691999,758805,9033,995301,68498,88145,59050,750294,825318,192521,199958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 979610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 979610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]