SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484271 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484271 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515279,698572,466839,951270,310363,228747,676467,910279,917166,793015,829517,899243,257720,214140,939740,968427,950258,183644,350174,623732,827869,35437,541642,685366,790349,1011351,163207,503970,806124,490334,955177,175052,982280,863370,75985,797820,435089,558992,1045065,249143,1036150,576264,138874,646617,74091,10367,270050,432258,263424,916391,131143,810834,800897,942676,832248,119424,417259,282823,449570,117161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001785s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]