SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339129 LIMIT 1 [ RunTime:0.000614s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339129 [ RunTime:0.004081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012000,680829,26463,802118,482607,333268,325325,1032489,1012753,213861,713869,248408,754048,501068,398334,713360,804742,217151,939289,718658,508193,1023910,607312,314424,538908,264017,210573,1034027,148567,743977,609230,1030010,795662,910360,313893,702555,972019,204612,285323,105871,3310,680221,43452,789748,615895,881445,223383,464340,649606,239712,904178,351713,631167,44163,456272,1015912,517909,903754,87674,548987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339129 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339129 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]