SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002992s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002639 LIMIT 1 [ RunTime:0.000901s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002639 [ RunTime:0.003349s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364404,1007363,450829,315758,465276,203597,815842,467322,40888,166660,141939,377167,504166,429819,154601,827868,981117,462102,602588,291167,687922,957300,463285,967319,994571,558540,528200,716863,694973,351359,549410,395137,740484,525313,20224,698091,548972,720499,523175,233002,9702,717,140316,403028,911442,720935,826787,593290,264300,18134,569326,858084,497992,547443,347221,73295,751745,788812,366297,239840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012566s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]