SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197401 LIMIT 1 [ RunTime:0.000617s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197401 [ RunTime:0.002908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548402,466768,381517,945856,366474,115388,472455,336439,361442,1001923,341304,911637,710772,551214,918154,593870,167614,894598,900630,640437,1011842,973428,454139,2791,113935,379905,393206,676250,223513,506327,130952,310058,372240,862369,704161,874810,763487,719020,874878,1027795,635155,46690,420691,346400,60171,222468,627995,919831,224813,180354,733154,645852,447189,860416,495445,193853,856883,3810,658648,870895) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000904s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001234s ]