SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002464s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 6841 LIMIT 1 [ RunTime:0.001120s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 6841 [ RunTime:0.004359s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307875,687832,335207,615778,879215,12448,24981,635684,315119,459147,48210,133968,969561,689930,627023,728540,737549,104857,36800,682749,186691,672661,435142,264490,882813,571630,11973,976909,765511,361853,273743,626978,849578,179012,535257,1019416,1004076,103605,67192,72145,119525,774562,755824,802589,40461,1009014,434501,363449,589932,1008842,78880,391194,677820,102619,748466,114407,341881,213948,870625,424083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 6841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 6841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]