SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005800s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104499 LIMIT 1 [ RunTime:0.000692s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104499 [ RunTime:0.002937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192988,234263,165949,342968,269615,844642,697935,130951,873059,199025,455033,857363,206992,329541,467588,864500,751893,779106,706325,416204,184002,50281,774363,557166,31878,305700,3578,480268,318265,149525,263905,59859,268421,44363,451756,931674,152255,116919,111589,653797,761071,347534,491722,213773,1036990,839661,374286,775925,879453,635244,409329,68978,73647,536894,662446,1039375,921714,367638,567654,981606) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]