SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385139 LIMIT 1 [ RunTime:0.001180s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385139 [ RunTime:0.003966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185087,923365,282607,196224,361919,144693,264911,774937,117729,743629,471447,195173,113102,192201,206928,194079,215007,654389,286794,610374,36262,989055,331504,1000036,80579,215884,793946,597116,411094,351057,452220,196322,903964,952276,3969,951065,130649,1001235,661547,950061,205148,701404,409341,879055,597553,374833,915231,647165,575166,245867,344594,237335,275290,613964,317969,527945,462336,842216,973725,175197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000897s ]