SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391814 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391814 [ RunTime:0.002970s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (421403,678018,840546,288286,718451,254489,414454,525428,1045458,322914,314152,211332,691104,294567,313208,163727,489994,560668,210365,842452,525721,1003526,468134,938050,381966,318114,556622,964217,366044,823099,383289,558380,300861,998310,938068,1002036,553952,342368,840704,214842,355913,746212,848446,453228,847993,544696,220975,1037794,548022,891908,218705,1032940,806616,842011,82391,79396,604149,982093,914394,25636) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001276s ]