SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033582 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033582 [ RunTime:0.002821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287322,369586,185498,429859,900115,302184,200512,98982,40987,163388,917447,153210,763661,888687,173173,131578,227360,306863,484579,100644,638839,130606,454192,481528,332874,814193,313858,78899,971139,696250,397228,781859,459853,582573,438592,13581,106872,508879,840509,339172,68399,108853,74508,589761,579411,94640,707746,159686,937187,956246,547477,552029,814769,484655,85060,120257,869581,340999,112769,499570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000803s ]