SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435470 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435470 [ RunTime:0.002245s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905083,124493,474802,942771,910205,151625,869472,89605,403755,280356,672000,232733,1021455,524128,758265,52281,276487,896668,836366,106798,858197,784070,956882,735540,436010,407088,964269,991973,791212,500051,850435,366087,491836,30491,882567,618460,440573,609453,226797,362062,35241,582606,81836,826714,307513,650448,398914,324214,756277,557437,160429,957785,717824,403912,40559,1001064,16245,706046,7313,407572) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000459s ]