SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466207 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466207 [ RunTime:0.002466s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (100126,399152,85711,621205,977116,458212,630585,802674,789939,334626,597723,497016,691969,239216,603925,622205,817125,937154,966158,1011121,205575,129429,970939,119576,669727,300761,574540,508226,57835,663060,424661,68141,30064,12297,791969,426719,315622,362228,531719,300681,413463,815172,1001434,207695,703569,412936,447434,384630,891271,929335,184821,1023580,354003,606381,50109,703981,309381,496492,426084,187524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]