SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019845 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019845 [ RunTime:0.002421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75339,141170,66417,337423,477422,80185,78012,417001,970149,143425,193332,510703,25758,352389,502820,228730,242843,854988,75576,727809,123401,354751,300524,859279,661440,185284,39466,417493,206709,711684,1038889,391096,154272,975620,385259,471920,855815,848387,428579,648203,402033,979176,1042438,84688,800103,780129,1001424,566041,882769,490830,564800,33137,896607,843505,180832,194529,395503,914856,750850,1008863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]