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` = 1040107 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040107 [ RunTime:0.001903s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51451,612561,318942,827836,737358,811823,290736,399143,239556,704506,858582,987963,324181,458504,885772,263372,6866,452335,577342,516562,134294,950139,876228,60842,50240,302565,329394,810296,305925,497697,96110,854754,713260,48758,639572,815398,708139,755695,44031,61703,985365,27243,192412,690335,991284,155628,689022,293652,891638,173277,10092,920290,675341,862203,173440,973709,695170,388061,756556,154596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]